Date-time literal (#...#)

Basic and Crystal syntax.

Usage

# alpha-numeric string #

This operator converts the enclosed alpha-numeric string to a DateTime value. The alpha-numeric should contain a date, a time, or a date and time representation that can be commonly recognized. Many formats are supported.

Examples

The following examples are applicable to both Basic and Crystal syntax:

#10:10am#

Returns a DateTime value of 10:10:00am.

#Oct. 19, 1999 #

Returns a DateTime value of October 19, 1999 12:00:00am.

#Oct. 19, 1999 10:10am#

Returns a DateTime value of October 19, 1999 10:10:00am.

Comments

If a formula returns a DateTime value, the format of the returned DateTime value is determined by the DateTime formatting applicable to that formula field.

Related topics

Date, Time, and DateTime (Basic syntax) under Simple data types (Basic syntax)

Date, Time, and DateTime (Crystal syntax) under Simple data types (Crystal syntax)



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com